
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_ShowRecruitmentStudent]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	Select * from dbo.JOL_Recruitment WHERE state='True' AND end_time>= getdate() 
	ORDER BY start_time desc ,  update_time desc
	
	RETURN


GO
